#!/usr/bin/env python
# -*- coding:utf-8 -*-

# file:studentModel.py
# author:Jackiex
# datetime:2023/5/18 15:34
# software: PyCharm

"""
this is function  description 
"""

# coding: utf-8
from sqlalchemy import BigInteger, Column, DateTime, Float, Integer, MetaData, String, Table
from sqlalchemy.schema import FetchedValue

from . import Base


class Student(Base):
    __tablename__ = 'student'

    autoID = Column(Integer, primary_key=True)
    studentID = Column(String(20), info='学生ID')
    name = Column(String(20), info='学生姓名')
    age = Column(Integer, info='学生年龄')
    classID = Column(Integer, info='学生所属班级ID')
    agenda = Column(String(4), info='性别')
    isDelete = Column(Integer, server_default=FetchedValue(), info='是否删除')
    addTime = Column(DateTime, server_default=FetchedValue(), info='记录添加时间')
